
	***************
	** Calculate dependency ratio statistics for paper
	***************
	
		use "$dir/data/population_projections_allcountries.dta", clear
	
	** Dependency ratios in SSA (using 60+)
		
		sum depratio_15to59_1990 if countryregion=="Sub-Saharan Africa" // 1.00
		sum depratio_15to59_2020 if countryregion=="Sub-Saharan Africa" // 0.89
		sum depratio_15to59_2050 if countryregion=="Sub-Saharan Africa" // 0.67
		sum depratio_15to59_2100 if countryregion=="Sub-Saharan Africa" // 0.66
	
	** Dependency ratios in SSA (using 65+)
	
		sum depratio_15to64_1990 if countryregion=="Sub-Saharan Africa" // 0.94
		sum depratio_15to64_2020 if countryregion=="Sub-Saharan Africa" // 0.83
		sum depratio_15to64_2050 if countryregion=="Sub-Saharan Africa" // 0.60
		sum depratio_15to64_2100 if countryregion=="Sub-Saharan Africa" // 0.53
	
	** Old age dependency ratios (using 60+)
	
		sum oldagedepratio_15to59_1990 if countryregion=="Sub-Saharan Africa" // 0.10
		sum oldagedepratio_15to59_2020 if countryregion=="Sub-Saharan Africa" // 0.09
		sum oldagedepratio_15to59_2050 if countryregion=="Sub-Saharan Africa" // 0.12
		sum oldagedepratio_15to59_2100 if countryregion=="Sub-Saharan Africa" // 0.31
		
	** Old age dependency ratios (using 65+)
	
		sum oldagedepratio_15to64_1990 if countryregion=="Sub-Saharan Africa" // 0.06
		sum oldagedepratio_15to64_2020 if countryregion=="Sub-Saharan Africa" // 0.06
		sum oldagedepratio_15to64_2050 if countryregion=="Sub-Saharan Africa" // 0.08
		sum oldagedepratio_15to64_2100 if countryregion=="Sub-Saharan Africa" // 0.21
		
	** Old age dependency ratios (using 60+): USA
	
		sum oldagedepratio_15to59_1990 if countryregion=="United States of America" // 0.27
		sum oldagedepratio_15to59_2020 if countryregion=="United States of America" // 0.38
		sum oldagedepratio_15to59_2050 if countryregion=="United States of America" // 0.54
		sum oldagedepratio_15to59_2100 if countryregion=="United States of America" // 0.73
		
	** Old age dependency ratios (using 65+): USA
	
		sum oldagedepratio_15to64_1990 if countryregion=="United States of America" // 0.19
		sum oldagedepratio_15to64_2020 if countryregion=="United States of America" // 0.25
		sum oldagedepratio_15to64_2050 if countryregion=="United States of America" // 0.39
		sum oldagedepratio_15to64_2100 if countryregion=="United States of America" // 0.55
		
		
		